home *** CD-ROM | disk | FTP | other *** search
- object Vendorfrm: TVendorfrm
- Left = 53
- Top = 58
- Width = 546
- Height = 391
- ActiveControl = Panel1
- BorderIcons = [biSystemMenu, biMinimize]
- Caption = 'Database Expression Example'
- Font.Color = clBlack
- Font.Height = -11
- Font.Name = 'MS Sans Serif'
- Font.Pitch = fpVariable
- Font.Style = []
- PixelsPerInch = 96
- Position = poScreenCenter
- OnCreate = FormCreate
- TextHeight = 13
- object Panel1: TPanel
- Left = 0
- Top = 0
- Width = 538
- Height = 41
- Align = alTop
- TabOrder = 0
- object Label12: TLabel
- Left = 8
- Top = 1
- Width = 106
- Height = 32
- Caption = 'Vendors'
- Color = clBtnFace
- Font.Color = clMaroon
- Font.Height = -27
- Font.Name = 'Arial'
- Font.Style = [fsBold, fsItalic]
- ParentColor = False
- ParentFont = False
- end
- object DBNavigator: TDBNavigator
- Left = 128
- Top = 8
- Width = 221
- Height = 25
- DataSource = DataSource1
- Ctl3D = False
- ParentCtl3D = False
- TabOrder = 0
- end
- object BitBtn2: TBitBtn
- Left = 439
- Top = 8
- Width = 72
- Height = 27
- TabOrder = 1
- Kind = bkClose
- end
- end
- object Panel2: TPanel
- Left = 0
- Top = 41
- Width = 538
- Height = 184
- Align = alTop
- BevelInner = bvLowered
- BorderWidth = 4
- Caption = 'Panel2'
- TabOrder = 1
- object ScrollBox: TScrollBox
- Left = 6
- Top = 6
- Width = 526
- Height = 172
- HorzScrollBar.Margin = 6
- HorzScrollBar.Range = 318
- VertScrollBar.Margin = 6
- VertScrollBar.Range = 160
- Align = alClient
- AutoScroll = False
- BorderStyle = bsNone
- TabOrder = 0
- object Label1: TLabel
- Left = 6
- Top = 6
- Width = 48
- Height = 13
- Caption = 'VendorNo'
- FocusControl = EditVendorNo
- end
- object Label2: TLabel
- Left = 62
- Top = 6
- Width = 62
- Height = 13
- Caption = 'VendorName'
- FocusControl = EditVendorName
- end
- object Label3: TLabel
- Left = 6
- Top = 44
- Width = 44
- Height = 13
- Caption = 'Address1'
- FocusControl = EditAddress
- end
- object Label4: TLabel
- Left = 162
- Top = 44
- Width = 44
- Height = 13
- Caption = 'Address2'
- FocusControl = EditAddress2
- end
- object Label5: TLabel
- Left = 6
- Top = 82
- Width = 17
- Height = 13
- Caption = 'City'
- FocusControl = EditCity
- end
- object Label6: TLabel
- Left = 112
- Top = 82
- Width = 25
- Height = 13
- Caption = 'State'
- FocusControl = EditState
- end
- object Label7: TLabel
- Left = 218
- Top = 82
- Width = 15
- Height = 13
- Caption = 'Zip'
- FocusControl = EditZip
- end
- object Label8: TLabel
- Left = 6
- Top = 120
- Width = 36
- Height = 13
- Caption = 'Country'
- FocusControl = EditCountry
- end
- object Label9: TLabel
- Left = 87
- Top = 120
- Width = 31
- Height = 13
- Caption = 'Phone'
- FocusControl = EditPhone
- end
- object Label10: TLabel
- Left = 168
- Top = 120
- Width = 20
- Height = 13
- Caption = 'FAX'
- FocusControl = EditFAX
- end
- object Label11: TLabel
- Left = 249
- Top = 120
- Width = 43
- Height = 13
- Caption = 'Preferred'
- FocusControl = EditPreferred
- end
- object EditVendorNo: TDBEdit
- Left = 6
- Top = 21
- Width = 50
- Height = 20
- DataField = 'VendorNo'
- DataSource = DataSource1
- MaxLength = 0
- TabOrder = 0
- end
- object EditVendorName: TDBEdit
- Left = 62
- Top = 21
- Width = 150
- Height = 20
- DataField = 'VendorName'
- DataSource = DataSource1
- MaxLength = 0
- TabOrder = 1
- end
- object EditAddress: TDBEdit
- Left = 6
- Top = 59
- Width = 150
- Height = 20
- DataField = 'Address1'
- DataSource = DataSource1
- MaxLength = 0
- TabOrder = 2
- end
- object EditAddress2: TDBEdit
- Left = 162
- Top = 59
- Width = 150
- Height = 20
- DataField = 'Address2'
- DataSource = DataSource1
- MaxLength = 0
- TabOrder = 3
- end
- object EditCity: TDBEdit
- Left = 6
- Top = 97
- Width = 100
- Height = 20
- DataField = 'City'
- DataSource = DataSource1
- MaxLength = 0
- TabOrder = 4
- end
- object EditState: TDBEdit
- Left = 112
- Top = 97
- Width = 100
- Height = 20
- DataField = 'State'
- DataSource = DataSource1
- MaxLength = 0
- TabOrder = 5
- end
- object EditZip: TDBEdit
- Left = 218
- Top = 97
- Width = 50
- Height = 20
- DataField = 'Zip'
- DataSource = DataSource1
- MaxLength = 0
- TabOrder = 6
- end
- object EditCountry: TDBEdit
- Left = 6
- Top = 135
- Width = 75
- Height = 20
- DataField = 'Country'
- DataSource = DataSource1
- MaxLength = 0
- TabOrder = 7
- end
- object EditPhone: TDBEdit
- Left = 87
- Top = 135
- Width = 75
- Height = 20
- DataField = 'Phone'
- DataSource = DataSource1
- MaxLength = 0
- TabOrder = 8
- end
- object EditFAX: TDBEdit
- Left = 168
- Top = 135
- Width = 75
- Height = 20
- DataField = 'FAX'
- DataSource = DataSource1
- MaxLength = 0
- TabOrder = 9
- end
- object EditPreferred: TDBEdit
- Left = 249
- Top = 135
- Width = 50
- Height = 20
- DataField = 'Preferred'
- DataSource = DataSource1
- MaxLength = 0
- TabOrder = 10
- end
- end
- end
- object Panel3: TPanel
- Left = 0
- Top = 225
- Width = 538
- Height = 96
- Align = alTop
- BevelInner = bvLowered
- BorderWidth = 4
- Caption = 'Panel3'
- TabOrder = 2
- object DBGrid1: TDBGrid
- Left = 6
- Top = 6
- Width = 526
- Height = 84
- Align = alClient
- BorderStyle = bsNone
- DataSource = DataSource2
- TabOrder = 0
- TitleFont.Color = clBlack
- TitleFont.Height = -11
- TitleFont.Name = 'MS Sans Serif'
- TitleFont.Pitch = fpVariable
- TitleFont.Style = []
- end
- end
- object ResultPanel: TPanel
- Left = 0
- Top = 321
- Width = 538
- Height = 43
- Align = alClient
- Alignment = taLeftJustify
- TabOrder = 3
- object Label13: TLabel
- Left = 6
- Top = 8
- Width = 43
- Height = 13
- Caption = 'RESULT'
- end
- object ResultEdit: TEdit
- Left = 54
- Top = 8
- Width = 391
- Height = 20
- Enabled = False
- TabOrder = 0
- end
- object BitBtn1: TBitBtn
- Left = 450
- Top = 8
- Width = 79
- Height = 25
- Caption = 'Formula'
- TabOrder = 1
- OnClick = BitBtn1Click
- Glyph.Data = {
- 78010000424D7801000000000000760000002800000020000000100000000100
- 04000000000000000000120B0000120B00000000000000000000000000000000
- 800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
- 333333333333333333333333333333333333333FFFFFFFFFFF33330000000000
- 03333377777777777F33333003333330033333377FF333377F33333300333333
- 0333333377FF33337F3333333003333303333333377FF3337333333333003333
- 333333333377FF3333333333333003333333333333377FF33333333333330033
- 3333333333337733333333333330033333333333333773333333333333003333
- 33333333337733333F3333333003333303333333377333337F33333300333333
- 03333333773333337F33333003333330033333377FFFFFF77F33330000000000
- 03333377777777777333333333333333333333333333333333330000}
- NumGlyphs = 2
- end
- end
- object DataSource1: TDataSource
- DataSet = Table1
- Left = 295
- Top = 53
- end
- object DataSource2: TDataSource
- DataSet = Table2
- Left = 349
- Top = 53
- end
- object Table1: TTable
- OnCalcFields = Table1CalcFields
- DatabaseName = 'DBDEMOS'
- TableName = 'vendors.db'
- Left = 268
- Top = 53
- object Table1VendorNo: TFloatField
- FieldName = 'VendorNo'
- end
- object Table1VendorName: TStringField
- FieldName = 'VendorName'
- Size = 30
- end
- object Table1Address1: TStringField
- FieldName = 'Address1'
- Size = 30
- end
- object Table1Address2: TStringField
- FieldName = 'Address2'
- Size = 30
- end
- object Table1City: TStringField
- FieldName = 'City'
- end
- object Table1State: TStringField
- FieldName = 'State'
- end
- object Table1Zip: TStringField
- FieldName = 'Zip'
- Size = 10
- end
- object Table1Country: TStringField
- FieldName = 'Country'
- Size = 15
- end
- object Table1Phone: TStringField
- FieldName = 'Phone'
- Size = 15
- end
- object Table1FAX: TStringField
- FieldName = 'FAX'
- Size = 15
- end
- object Table1Preferred: TBooleanField
- FieldName = 'Preferred'
- end
- object Table1Dummy: TStringField
- Calculated = True
- FieldName = 'Dummy'
- Size = 255
- end
- end
- object Table2: TTable
- DatabaseName = 'DBDEMOS'
- IndexFieldNames = 'VendorNo'
- MasterFields = 'VendorNo'
- MasterSource = DataSource1
- TableName = 'parts.db'
- Left = 322
- Top = 53
- object Table2PartNo: TFloatField
- FieldName = 'PartNo'
- end
- object Table2VendorNo: TFloatField
- FieldName = 'VendorNo'
- ReadOnly = True
- Visible = False
- end
- object Table2Description: TStringField
- FieldName = 'Description'
- Size = 30
- end
- object Table2OnHand: TFloatField
- FieldName = 'OnHand'
- end
- object Table2OnOrder: TFloatField
- FieldName = 'OnOrder'
- end
- object Table2Cost: TCurrencyField
- FieldName = 'Cost'
- Currency = True
- end
- object Table2ListPrice: TCurrencyField
- FieldName = 'ListPrice'
- Currency = True
- end
- end
- end
-